Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	450000
Missing cells	1816686
Missing cells (%)	20.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	68.7 MiB
Average record size in memory	160.0 B

Variable types

Categorical	11
Numeric	9

Alerts

`reassigned_order` has constant value "1.0"	Constant
`order_time` has a high cardinality: 252868 distinct values	High cardinality
`allot_time` has a high cardinality: 246871 distinct values	High cardinality
`accept_time` has a high cardinality: 254201 distinct values	High cardinality
`pickup_time` has a high cardinality: 257117 distinct values	High cardinality
`delivered_time` has a high cardinality: 257067 distinct values	High cardinality
`cancelled_time` has a high cardinality: 5176 distinct values	High cardinality
`alloted_orders` is highly correlated with `delivered_orders` and 1 other fields	High correlation
`delivered_orders` is highly correlated with `alloted_orders` and 1 other fields	High correlation
`lifetime_order_count` is highly correlated with `alloted_orders` and 1 other fields	High correlation
`alloted_orders` is highly correlated with `delivered_orders`	High correlation
`delivered_orders` is highly correlated with `alloted_orders`	High correlation
`alloted_orders` is highly correlated with `delivered_orders`	High correlation
`delivered_orders` is highly correlated with `alloted_orders`	High correlation
`cancelled` is highly correlated with `reassigned_order`	High correlation
`reassignment_reason` is highly correlated with `reassigned_order`	High correlation
`order_date` is highly correlated with `reassigned_order`	High correlation
`reassigned_order` is highly correlated with `cancelled` and 3 other fields	High correlation
`reassignment_method` is highly correlated with `reassigned_order`	High correlation
`order_id` is highly correlated with `order_date`	High correlation
`order_date` is highly correlated with `order_id`	High correlation
`alloted_orders` is highly correlated with `delivered_orders` and 1 other fields	High correlation
`delivered_orders` is highly correlated with `alloted_orders` and 1 other fields	High correlation
`undelivered_orders` is highly correlated with `alloted_orders` and 1 other fields	High correlation
`delivered_time` has 5218 (1.2%) missing values	Missing
`alloted_orders` has 16948 (3.8%) missing values	Missing
`delivered_orders` has 17341 (3.9%) missing values	Missing
`undelivered_orders` has 17341 (3.9%) missing values	Missing
`reassignment_method` has 436256 (96.9%) missing values	Missing
`reassignment_reason` has 436247 (96.9%) missing values	Missing
`reassigned_order` has 436247 (96.9%) missing values	Missing
`cancelled_time` has 444782 (98.8%) missing values	Missing
`order_time` is uniformly distributed	Uniform
`allot_time` is uniformly distributed	Uniform
`accept_time` is uniformly distributed	Uniform
`pickup_time` is uniformly distributed	Uniform
`delivered_time` is uniformly distributed	Uniform
`cancelled_time` is uniformly distributed	Uniform
`undelivered_orders` has 232686 (51.7%) zeros	Zeros

Reproduction

Analysis started	2022-02-13 05:37:34.729919
Analysis finished	2022-02-13 05:39:21.262105
Duration	1 minute and 46.53 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

order_time
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	252868
Distinct (%)	56.2%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

2021-01-30 14:38:36	11
2021-01-30 13:30:43	11
2021-01-26 13:57:44	10
2021-01-30 13:33:54	10
2021-02-03 14:11:49	10
Other values (252863)	449948

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	133840 ?
Unique (%)	29.7%

Sample

1st row	2021-01-26 02:21:35
2nd row	2021-01-26 02:33:16
3rd row	2021-01-26 02:39:49
4th row	2021-01-26 02:47:53
5th row	2021-01-26 03:06:30

Common Values

Value	Count	Frequency (%)
2021-01-30 14:38:36	11	< 0.1%
2021-01-30 13:30:43	11	< 0.1%
2021-01-26 13:57:44	10	< 0.1%
2021-01-30 13:33:54	10	< 0.1%
2021-02-03 14:11:49	10	< 0.1%
2021-02-03 13:42:55	10	< 0.1%
2021-01-30 13:33:37	10	< 0.1%
2021-02-02 13:35:14	10	< 0.1%
2021-01-28 15:43:05	10	< 0.1%
2021-01-29 14:30:32	10	< 0.1%
Other values (252858)	449898	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2021-02-05	42341	4.7%
2021-02-03	41447	4.6%
2021-01-29	41207	4.6%
2021-02-02	40875	4.5%
2021-01-28	40783	4.5%
2021-02-04	39685	4.4%
2021-01-31	39254	4.4%
2021-01-27	39015	4.3%
2021-01-26	38090	4.2%
2021-02-01	37833	4.2%
Other values (43385)	499470	55.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

order_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	449999
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	369143.0808

Minimum	118350
Maximum	594842
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	118350
5-th percentile	167343.95
Q1	257342.75
median	369842.5
Q3	482342.25
95-th percentile	572342.05
Maximum	594842
Range	476492
Interquartile range (IQR)	224999.5

Descriptive statistics

Standard deviation	131146.9064
Coefficient of variation (CV)	0.355273912
Kurtosis	-1.149146297
Mean	369143.0808
Median Absolute Deviation (MAD)	112500
Skewness	-0.03426737717
Sum	1.661143863 × 10¹¹
Variance	1.719951106 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
181402	2	< 0.1%
556753	1	< 0.1%
306422	1	< 0.1%
306433	1	< 0.1%
306430	1	< 0.1%
306429	1	< 0.1%
306428	1	< 0.1%
306431	1	< 0.1%
306432	1	< 0.1%
306427	1	< 0.1%
Other values (449989)	449989	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
118350	1	< 0.1%
118351	1	< 0.1%
118352	1	< 0.1%
118353	1	< 0.1%
118354	1	< 0.1%
118355	1	< 0.1%
118356	1	< 0.1%
118357	1	< 0.1%
118358	1	< 0.1%
118359	1	< 0.1%

Value	Count	Frequency (%)
594842	1	< 0.1%
594841	1	< 0.1%
594840	1	< 0.1%
594839	1	< 0.1%
594838	1	< 0.1%
594837	1	< 0.1%
594836	1	< 0.1%
594835	1	< 0.1%
594834	1	< 0.1%
594833	1	< 0.1%

order_date
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

2021-02-05 00:00:00	42341
2021-02-03 00:00:00	41447
2021-01-29 00:00:00	41207
2021-02-02 00:00:00	40875
2021-01-28 00:00:00	40783
Other values (7)	243347

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2021-01-26 00:00:00
2nd row	2021-01-26 00:00:00
3rd row	2021-01-26 00:00:00
4th row	2021-01-26 00:00:00
5th row	2021-01-26 00:00:00

Common Values

Value	Count	Frequency (%)
2021-02-05 00:00:00	42341	9.4%
2021-02-03 00:00:00	41447	9.2%
2021-01-29 00:00:00	41207	9.2%
2021-02-02 00:00:00	40875	9.1%
2021-01-28 00:00:00	40783	9.1%
2021-02-04 00:00:00	39685	8.8%
2021-01-31 00:00:00	39254	8.7%
2021-01-27 00:00:00	39015	8.7%
2021-01-26 00:00:00	38090	8.5%
2021-02-01 00:00:00	37833	8.4%
Other values (2)	49470	11.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	450000	50.0%
2021-02-05	42341	4.7%
2021-02-03	41447	4.6%
2021-01-29	41207	4.6%
2021-02-02	40875	4.5%
2021-01-28	40783	4.5%
2021-02-04	39685	4.4%
2021-01-31	39254	4.4%
2021-01-27	39015	4.3%
2021-01-26	38090	4.2%
Other values (3)	87303	9.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

allot_time
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	246871
Distinct (%)	54.9%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

2021-01-29 14:18:11	13
2021-02-03 14:56:54	13
2021-01-29 17:12:47	12
2021-01-29 16:19:15	12
2021-01-30 13:33:29	12
Other values (246866)	449938

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	129910 ?
Unique (%)	28.9%

Sample

1st row	2021-01-26 02:21:59
2nd row	2021-01-26 02:33:57
3rd row	2021-01-26 02:39:57
4th row	2021-01-26 02:48:25
5th row	2021-01-26 03:07:21

Common Values

Value	Count	Frequency (%)
2021-01-29 14:18:11	13	< 0.1%
2021-02-03 14:56:54	13	< 0.1%
2021-01-29 17:12:47	12	< 0.1%
2021-01-29 16:19:15	12	< 0.1%
2021-01-30 13:33:29	12	< 0.1%
2021-02-01 15:30:46	12	< 0.1%
2021-02-05 16:01:45	11	< 0.1%
2021-02-04 17:16:55	11	< 0.1%
2021-01-29 13:43:12	11	< 0.1%
2021-01-30 14:07:23	10	< 0.1%
Other values (246861)	449883	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2021-02-05	42341	4.7%
2021-02-03	41447	4.6%
2021-01-29	41207	4.6%
2021-02-02	40875	4.5%
2021-01-28	40783	4.5%
2021-02-04	39685	4.4%
2021-01-31	39254	4.4%
2021-01-27	39015	4.3%
2021-01-26	38090	4.2%
2021-02-01	37833	4.2%
Other values (43527)	499470	55.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

accept_time
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	254201
Distinct (%)	56.5%
Missing	157
Missing (%)	< 0.1%
Memory size	3.4 MiB

2021-01-27 16:03:12	15
2021-02-01 13:32:55	13
2021-01-31 13:31:30	12
2021-01-29 13:35:13	11
2021-01-28 13:34:46	11
Other values (254196)	449781

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	135348 ?
Unique (%)	30.1%

Sample

1st row	2021-01-26 02:22:08
2nd row	2021-01-26 02:34:45
3rd row	2021-01-26 02:40:13
4th row	2021-01-26 02:49:06
5th row	2021-01-26 03:07:57

Common Values

Value	Count	Frequency (%)
2021-01-27 16:03:12	15	< 0.1%
2021-02-01 13:32:55	13	< 0.1%
2021-01-31 13:31:30	12	< 0.1%
2021-01-29 13:35:13	11	< 0.1%
2021-01-28 13:34:46	11	< 0.1%
2021-02-05 16:31:47	10	< 0.1%
2021-01-31 17:03:36	10	< 0.1%
2021-02-01 15:33:34	10	< 0.1%
2021-02-05 14:47:12	10	< 0.1%
2021-01-28 14:24:33	10	< 0.1%
Other values (254191)	449731	99.9%
(Missing)	157	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2021-02-05	42325	4.7%
2021-02-03	41436	4.6%
2021-01-29	41192	4.6%
2021-02-02	40864	4.5%
2021-01-28	40775	4.5%
2021-02-04	39673	4.4%
2021-01-31	39236	4.4%
2021-01-27	39006	4.3%
2021-01-26	38076	4.2%
2021-02-01	37815	4.2%
Other values (43911)	499288	55.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

pickup_time
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	257117
Distinct (%)	57.4%
Missing	2421
Missing (%)	0.5%
Memory size	3.4 MiB

2021-01-28 15:29:58	11
2021-01-30 14:12:40	10
2021-01-28 15:52:01	10
2021-01-29 14:50:58	10
2021-02-05 15:06:01	10
Other values (257112)	447528

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	139375 ?
Unique (%)	31.1%

Sample

1st row	2021-01-26 02:32:51
2nd row	2021-01-26 02:50:25
3rd row	2021-01-26 02:56:00
4th row	2021-01-26 03:21:51
5th row	2021-01-26 03:31:38

Common Values

Value	Count	Frequency (%)
2021-01-28 15:29:58	11	< 0.1%
2021-01-30 14:12:40	10	< 0.1%
2021-01-28 15:52:01	10	< 0.1%
2021-01-29 14:50:58	10	< 0.1%
2021-02-05 15:06:01	10	< 0.1%
2021-01-30 15:22:40	10	< 0.1%
2021-02-02 16:14:37	10	< 0.1%
2021-01-30 15:22:11	10	< 0.1%
2021-02-02 14:19:50	10	< 0.1%
2021-02-05 14:51:14	9	< 0.1%
Other values (257107)	447479	99.4%
(Missing)	2421	0.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2021-02-05	42117	4.7%
2021-02-03	41247	4.6%
2021-01-29	41010	4.6%
2021-02-02	40674	4.5%
2021-01-28	40585	4.5%
2021-02-04	39511	4.4%
2021-01-31	39065	4.4%
2021-01-27	38824	4.3%
2021-01-26	37883	4.2%
2021-02-01	37667	4.2%
Other values (44674)	496575	55.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

delivered_time
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	257067
Distinct (%)	57.8%
Missing	5218
Missing (%)	1.2%
Memory size	3.4 MiB

2021-01-30 14:38:14	12
2021-02-01 16:27:22	9
2021-01-31 15:45:09	9
2021-02-01 15:54:50	9
2021-01-29 14:26:56	9
Other values (257062)	444734

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	140784 ?
Unique (%)	31.7%

Sample

1st row	2021-01-26 02:49:47
2nd row	2021-01-26 03:11:15
3rd row	2021-01-26 03:12:46
4th row	2021-01-26 03:41:05
5th row	2021-01-26 04:00:15

Common Values

Value	Count	Frequency (%)
2021-01-30 14:38:14	12	< 0.1%
2021-02-01 16:27:22	9	< 0.1%
2021-01-31 15:45:09	9	< 0.1%
2021-02-01 15:54:50	9	< 0.1%
2021-01-29 14:26:56	9	< 0.1%
2021-01-30 14:38:18	9	< 0.1%
2021-02-05 15:53:02	9	< 0.1%
2021-01-27 14:25:53	9	< 0.1%
2021-01-28 16:38:24	9	< 0.1%
2021-02-03 15:41:30	9	< 0.1%
Other values (257057)	444689	98.8%
(Missing)	5218	1.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2021-02-05	41842	4.7%
2021-02-03	40985	4.6%
2021-01-29	40754	4.6%
2021-02-02	40461	4.5%
2021-01-28	40292	4.5%
2021-02-04	39262	4.4%
2021-01-31	38899	4.4%
2021-01-27	38609	4.3%
2021-01-26	37628	4.2%
2021-02-01	37450	4.2%
Other values (45275)	493382	55.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

rider_id
Real number (ℝ_≥0)

Distinct	19537
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7763.244016

Minimum	0
Maximum	21566
Zeros	7
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	519
Q1	2805
median	6754
Q3	11965
95-th percentile	18050
Maximum	21566
Range	21566
Interquartile range (IQR)	9160

Descriptive statistics

Standard deviation	5592.880135
Coefficient of variation (CV)	0.7204308049
Kurtosis	-0.8427443266
Mean	7763.244016
Median Absolute Deviation (MAD)	4436
Skewness	0.4790871039
Sum	3493459807
Variance	31280308.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
237	228	0.1%
190	213	< 0.1%
11998	209	< 0.1%
170	203	< 0.1%
853	200	< 0.1%
747	199	< 0.1%
2280	195	< 0.1%
4921	194	< 0.1%
12709	191	< 0.1%
453	190	< 0.1%
Other values (19527)	447978	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7	< 0.1%
1	16	< 0.1%
2	28	< 0.1%
4	3	< 0.1%
5	19	< 0.1%
6	15	< 0.1%
9	29	< 0.1%
10	97	< 0.1%
11	25	< 0.1%
12	24	< 0.1%

Value	Count	Frequency (%)
21566	1	< 0.1%
21565	1	< 0.1%
21564	1	< 0.1%
21563	1	< 0.1%
21562	1	< 0.1%
21561	1	< 0.1%
21560	2	< 0.1%
21559	2	< 0.1%
21558	2	< 0.1%
21557	1	< 0.1%

first_mile_distance
Real number (ℝ_≥0)

Distinct	93743
Distinct (%)	20.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.229888977

Minimum	0.0001342587859
Maximum	42.0381
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0.0001342587859
5-th percentile	0.05458151785
Q1	0.539575
median	1.1387
Q3	1.853
95-th percentile	2.7079
Maximum	42.0381
Range	42.03796574
Interquartile range (IQR)	1.313425

Descriptive statistics

Standard deviation	0.8461826096
Coefficient of variation (CV)	0.688015443
Kurtosis	12.36678626
Mean	1.229888977
Median Absolute Deviation (MAD)	0.6482
Skewness	0.7588916893
Sum	553450.0398
Variance	0.7160250088
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.7153	39	< 0.1%
0.7404	39	< 0.1%
0.6965	36	< 0.1%
0.6959	36	< 0.1%
0.7241	34	< 0.1%
0.6578	34	< 0.1%
0.6883	34	< 0.1%
1.0009	34	< 0.1%
1.5356	34	< 0.1%
0.6174	34	< 0.1%
Other values (93733)	449646	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0001342587859	2	< 0.1%
0.0002122817797	1	< 0.1%
0.0002848058939	1	< 0.1%
0.000328865519	1	< 0.1%
0.0003797411919	2	< 0.1%
0.0004027763578	5	< 0.1%
0.00041381337	1	< 0.1%
0.0004452860177	2	< 0.1%
0.0004552936947	3	< 0.1%
0.0004650860772	2	< 0.1%

Value	Count	Frequency (%)
42.0381	1	< 0.1%
17.3442	1	< 0.1%
11.6741	1	< 0.1%
11.3649	1	< 0.1%
10.7525	1	< 0.1%
10.6994	1	< 0.1%
10.5839	1	< 0.1%
10.0546	1	< 0.1%
9.6695	1	< 0.1%
9.6079	1	< 0.1%

last_mile_distance
Real number (ℝ_≥0)

Distinct	1331
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.968872711

Minimum	0
Maximum	22.41
Zeros	94
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0.5
Q1	1.47
median	2.67
Q3	4.22
95-th percentile	6.22
Maximum	22.41
Range	22.41
Interquartile range (IQR)	2.75

Descriptive statistics

Standard deviation	1.884123753
Coefficient of variation (CV)	0.6346259797
Kurtosis	0.8795462088
Mean	2.968872711
Median Absolute Deviation (MAD)	1.33
Skewness	0.8267706027
Sum	1335992.72
Variance	3.549922316
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.58	1143	0.3%
1.5	1121	0.2%
1.97	1119	0.2%
1.45	1111	0.2%
1.63	1110	0.2%
1.46	1109	0.2%
1.54	1107	0.2%
1.32	1105	0.2%
1.76	1104	0.2%
1.67	1104	0.2%
Other values (1321)	438867	97.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	94	< 0.1%
0.01	170	< 0.1%
0.02	210	< 0.1%
0.03	193	< 0.1%
0.04	237	0.1%
0.05	253	0.1%
0.06	291	0.1%
0.07	353	0.1%
0.08	415	0.1%
0.09	482	0.1%

Value	Count	Frequency (%)
22.41	1	< 0.1%
22.26	1	< 0.1%
21.27	1	< 0.1%
21.21	1	< 0.1%
21.2	1	< 0.1%
21.12	1	< 0.1%
19.81	1	< 0.1%
18.13	1	< 0.1%
17.27	1	< 0.1%
16.85	1	< 0.1%

alloted_orders
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	510
Distinct (%)	0.1%
Missing	16948
Missing (%)	3.8%
Infinite	0
Infinite (%)	0.0%
Mean	104.6209093

Minimum	1
Maximum	567
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	1
5-th percentile	7
Q1	36
median	81
Q3	147
95-th percentile	289
Maximum	567
Range	566
Interquartile range (IQR)	111

Descriptive statistics

Standard deviation	90.13549192
Coefficient of variation (CV)	0.8615437636
Kurtosis	2.098562998
Mean	104.6209093
Median Absolute Deviation (MAD)	52
Skewness	1.384162248
Sum	45306294
Variance	8124.406904
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	3764	0.8%
5	3717	0.8%
4	3648	0.8%
2	3589	0.8%
7	3586	0.8%
3	3513	0.8%
10	3424	0.8%
8	3309	0.7%
9	3168	0.7%
12	3132	0.7%
Other values (500)	398202	88.5%
(Missing)	16948	3.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2991	0.7%
2	3589	0.8%
3	3513	0.8%
4	3648	0.8%
5	3717	0.8%
6	3764	0.8%
7	3586	0.8%
8	3309	0.7%
9	3168	0.7%
10	3424	0.8%

Value	Count	Frequency (%)
567	12	< 0.1%
565	18	< 0.1%
563	17	< 0.1%
561	18	< 0.1%
558	9	< 0.1%
555	25	< 0.1%
553	21	< 0.1%
545	28	< 0.1%
540	21	< 0.1%
536	20	< 0.1%

delivered_orders
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	504
Distinct (%)	0.1%
Missing	17341
Missing (%)	3.9%
Infinite	0
Infinite (%)	0.0%
Mean	103.9504483

Minimum	1
Maximum	562
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	1
5-th percentile	7
Q1	36
median	81
Q3	146
95-th percentile	288
Maximum	562
Range	561
Interquartile range (IQR)	110

Descriptive statistics

Standard deviation	89.63964602
Coefficient of variation (CV)	0.8623305383
Kurtosis	2.117421984
Mean	103.9504483
Median Absolute Deviation (MAD)	52
Skewness	1.389351151
Sum	44975097
Variance	8035.266138
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	3798	0.8%
4	3698	0.8%
5	3697	0.8%
7	3645	0.8%
3	3528	0.8%
2	3525	0.8%
10	3403	0.8%
8	3322	0.7%
13	3228	0.7%
20	3207	0.7%
Other values (494)	397608	88.4%
(Missing)	17341	3.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2949	0.7%
2	3525	0.8%
3	3528	0.8%
4	3698	0.8%
5	3697	0.8%
6	3798	0.8%
7	3645	0.8%
8	3322	0.7%
9	3180	0.7%
10	3403	0.8%

Value	Count	Frequency (%)
562	12	< 0.1%
560	18	< 0.1%
559	17	< 0.1%
557	18	< 0.1%
553	9	< 0.1%
550	25	< 0.1%
548	21	< 0.1%
540	28	< 0.1%
535	21	< 0.1%
531	20	< 0.1%

cancelled
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

0	444782
1	5218

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	444782	98.8%
1	5218	1.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	444782	98.8%
1	5218	1.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

undelivered_orders
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	10
Distinct (%)	< 0.1%
Missing	17341
Missing (%)	3.9%
Infinite	0
Infinite (%)	0.0%
Mean	0.7641653126

Minimum	0
Maximum	9
Zeros	232686
Zeros (%)	51.7%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	9
Range	9
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.066473491
Coefficient of variation (CV)	1.395605732
Kurtosis	4.67331547
Mean	0.7641653126
Median Absolute Deviation (MAD)	0
Skewness	1.848054475
Sum	330623
Variance	1.137365706
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	232686	51.7%
1	118103	26.2%
2	50582	11.2%
3	20011	4.4%
4	7733	1.7%
5	1851	0.4%
6	932	0.2%
7	600	0.1%
8	105	< 0.1%
9	56	< 0.1%
(Missing)	17341	3.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	232686	51.7%
1	118103	26.2%
2	50582	11.2%
3	20011	4.4%
4	7733	1.7%
5	1851	0.4%
6	932	0.2%
7	600	0.1%
8	105	< 0.1%
9	56	< 0.1%

Value	Count	Frequency (%)
9	56	< 0.1%
8	105	< 0.1%
7	600	0.1%
6	932	0.2%
5	1851	0.4%
4	7733	1.7%
3	20011	4.4%
2	50582	11.2%
1	118103	26.2%
0	232686	51.7%

lifetime_order_count
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2887
Distinct (%)	0.6%
Missing	53
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	853.6406643

Minimum	0
Maximum	30469
Zeros	5
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	50
Q1	165
median	396
Q3	948
95-th percentile	3013
Maximum	30469
Range	30469
Interquartile range (IQR)	783

Descriptive statistics

Standard deviation	1502.976162
Coefficient of variation (CV)	1.76066608
Kurtosis	77.96603641
Mean	853.6406643
Median Absolute Deviation (MAD)	287
Skewness	6.756972165
Sum	384093056
Variance	2258937.343
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	1609	0.4%
51	1230	0.3%
290	1201	0.3%
130	1170	0.3%
166	1162	0.3%
228	1161	0.3%
99	1104	0.2%
84	1091	0.2%
57	1086	0.2%
106	1084	0.2%
Other values (2877)	438049	97.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5	< 0.1%
1	172	< 0.1%
2	232	0.1%
3	293	0.1%
4	280	0.1%
5	381	0.1%
6	344	0.1%
7	428	0.1%
8	369	0.1%
9	375	0.1%

Value	Count	Frequency (%)
30469	50	< 0.1%
27972	55	< 0.1%
26810	26	< 0.1%
24933	4	< 0.1%
24022	80	< 0.1%
23626	33	< 0.1%
22581	34	< 0.1%
22033	27	< 0.1%
21995	10	< 0.1%
21938	7	< 0.1%

reassignment_method
Categorical

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	436256
Missing (%)	96.9%
Memory size	3.4 MiB

auto	13383
manual	361

Length

Max length	6
Median length	4
Mean length	4.052532014
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	auto
2nd row	auto
3rd row	auto
4th row	auto
5th row	auto

Common Values

Value	Count	Frequency (%)
auto	13383	3.0%
manual	361	0.1%
(Missing)	436256	96.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
auto	13383	97.4%
manual	361	2.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

reassignment_reason
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	436247
Missing (%)	96.9%
Memory size	3.4 MiB

Auto Reassignment basis Inaction. coreengine.tasks.repush_order_to_aa_bucket	7212
Reassignment Request from SE portal.	5300
Reassign	1241

Length

Max length	76
Median length	76
Mean length	54.44921108
Min length	8

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Reassignment Request from SE portal.
2nd row	Reassignment Request from SE portal.
3rd row	Auto Reassignment basis Inaction. coreengine.tasks.repush_order_to_aa_bucket
4th row	Auto Reassignment basis Inaction. coreengine.tasks.repush_order_to_aa_bucket
5th row	Reassignment Request from SE portal.

Common Values

Value	Count	Frequency (%)
Auto Reassignment basis Inaction. coreengine.tasks.repush_order_to_aa_bucket	7212	1.6%
Reassignment Request from SE portal.	5300	1.2%
Reassign	1241	0.3%
(Missing)	436247	96.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
reassignment	12512	19.6%
auto	7212	11.3%
basis	7212	11.3%
inaction	7212	11.3%
coreengine.tasks.repush_order_to_aa_bucket	7212	11.3%
request	5300	8.3%
from	5300	8.3%
se	5300	8.3%
portal	5300	8.3%
reassign	1241	1.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

reassigned_order
Categorical

CONSTANT
HIGH CORRELATION
MISSING
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	436247
Missing (%)	96.9%
Memory size	3.4 MiB

1.0	13753

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	13753	3.1%
(Missing)	436247	96.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1.0	13753	100.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

session_time
Real number (ℝ_≥0)

Distinct	65872
Distinct (%)	14.8%
Missing	3675
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	220.4747785

Minimum	0
Maximum	1298.966667
Zeros	16
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	9.8
Q1	84.1
median	175.55
Q3	316.7666667
95-th percentile	581.2833333
Maximum	1298.966667
Range	1298.966667
Interquartile range (IQR)	232.6666667

Descriptive statistics

Standard deviation	176.713853
Coefficient of variation (CV)	0.8015150494
Kurtosis	0.3002308299
Mean	220.4747785
Median Absolute Deviation (MAD)	104.2
Skewness	0.986198014
Sum	98403405.53
Variance	31227.78585
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.06666666667	155	< 0.1%
0.03333333333	144	< 0.1%
0.1166666667	136	< 0.1%
0.15	132	< 0.1%
0.05	129	< 0.1%
0.08333333333	124	< 0.1%
240	120	< 0.1%
0.1	118	< 0.1%
0.1333333333	117	< 0.1%
0.1666666667	117	< 0.1%
Other values (65862)	445033	98.9%
(Missing)	3675	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16	< 0.1%
0.01666666667	115	< 0.1%
0.03333333333	144	< 0.1%
0.05	129	< 0.1%
0.06666666667	155	< 0.1%
0.08333333333	124	< 0.1%
0.1	118	< 0.1%
0.1166666667	136	< 0.1%
0.1333333333	117	< 0.1%
0.15	132	< 0.1%

Value	Count	Frequency (%)
1298.966667	1	< 0.1%
1294.433333	1	< 0.1%
1250.333333	1	< 0.1%
1183.566667	1	< 0.1%
1141.533333	1	< 0.1%
1096.833333	1	< 0.1%
1076.85	1	< 0.1%
1057.483333	1	< 0.1%
1043.866667	1	< 0.1%
1038.216667	1	< 0.1%

cancelled_time
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	5176
Distinct (%)	99.2%
Missing	444782
Missing (%)	98.8%
Memory size	3.4 MiB

2021-01-29 17:02:50	2
2021-01-30 16:10:49	2
2021-01-30 16:51:46	2
2021-02-01 14:44:04	2
2021-02-03 15:16:23	2
Other values (5171)	5208

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5134 ?
Unique (%)	98.4%

Sample

1st row	2021-01-26 04:51:46
2nd row	2021-01-26 04:08:50
3rd row	2021-01-26 05:45:51
4th row	2021-01-26 05:10:15
5th row	2021-01-26 04:40:46

Common Values

Value	Count	Frequency (%)
2021-01-29 17:02:50	2	< 0.1%
2021-01-30 16:10:49	2	< 0.1%
2021-01-30 16:51:46	2	< 0.1%
2021-02-01 14:44:04	2	< 0.1%
2021-02-03 15:16:23	2	< 0.1%
2021-01-28 17:27:57	2	< 0.1%
2021-01-30 15:06:39	2	< 0.1%
2021-01-27 16:42:16	2	< 0.1%
2021-01-30 15:47:21	2	< 0.1%
2021-01-30 15:45:22	2	< 0.1%
Other values (5166)	5198	1.2%
(Missing)	444782	98.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2021-01-30	723	6.9%
2021-02-05	496	4.8%
2021-01-28	483	4.6%
2021-02-03	464	4.4%
2021-01-29	448	4.3%
2021-02-04	433	4.1%
2021-02-02	428	4.1%
2021-01-27	427	4.1%
2021-01-26	421	4.0%
2021-01-31	394	3.8%
Other values (4820)	5719	54.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	order_time	order_id	order_date	allot_time	accept_time	pickup_time	delivered_time	rider_id	first_mile_distance	last_mile_distance	alloted_orders	delivered_orders	undelivered_orders	lifetime_order_count	reassignment_method	reassignment_reason	reassigned_order	session_time	cancelled_time
0	2021-01-26 02:21:35	556753	2021-01-26 00:00:00	2021-01-26 02:21:59	2021-01-26 02:22:08	2021-01-26 02:32:51	2021-01-26 02:49:47	11696	1.566600	2.65	46.0	46.0	0.0	621.0	NaN	NaN	NaN	NaN	NaN
1	2021-01-26 02:33:16	556754	2021-01-26 00:00:00	2021-01-26 02:33:57	2021-01-26 02:34:45	2021-01-26 02:50:25	2021-01-26 03:11:15	18117	2.520700	2.76	8.0	8.0	0.0	105.0	NaN	NaN	NaN	3.266667	NaN
2	2021-01-26 02:39:49	556755	2021-01-26 00:00:00	2021-01-26 02:39:57	2021-01-26 02:40:13	2021-01-26 02:56:00	2021-01-26 03:12:46	18623	2.207400	4.80	1.0	1.0	0.0	66.0	NaN	NaN	NaN	9.816667	NaN
3	2021-01-26 02:47:53	556756	2021-01-26 00:00:00	2021-01-26 02:48:25	2021-01-26 02:49:06	2021-01-26 03:21:51	2021-01-26 03:41:05	15945	2.189400	6.38	1.0	1.0	0.0	127.0	NaN	NaN	NaN	17.533333	NaN
4	2021-01-26 03:06:30	556757	2021-01-26 00:00:00	2021-01-26 03:07:21	2021-01-26 03:07:57	2021-01-26 03:31:38	2021-01-26 04:00:15	17589	2.787000	4.01	34.0	34.0	0.0	84.0	NaN	NaN	NaN	1.350000	NaN
5	2021-01-26 03:07:16	556758	2021-01-26 00:00:00	2021-01-26 03:12:14	2021-01-26 03:12:27	2021-01-26 03:25:36	2021-01-26 03:45:51	1469	2.481800	5.18	296.0	294.0	2.0	1506.0	NaN	NaN	NaN	NaN	NaN
6	2021-01-26 03:10:50	556759	2021-01-26 00:00:00	2021-01-26 03:11:18	2021-01-26 03:12:05	2021-01-26 03:19:31	2021-01-26 03:26:04	8851	2.809100	3.40	45.0	45.0	0.0	1460.0	NaN	NaN	NaN	NaN	NaN
7	2021-01-26 03:14:10	556760	2021-01-26 00:00:00	2021-01-26 03:14:38	2021-01-26 03:14:44	2021-01-26 03:33:53	2021-01-26 03:42:38	8493	0.025681	0.16	54.0	53.0	1.0	270.0	NaN	NaN	NaN	44.166667	NaN
8	2021-01-26 03:14:20	556761	2021-01-26 00:00:00	2021-01-26 03:14:50	2021-01-26 03:15:14	2021-01-26 04:00:02	2021-01-26 04:13:31	11543	2.444200	2.86	29.0	29.0	0.0	955.0	NaN	NaN	NaN	2.500000	NaN
9	2021-01-26 03:15:18	556762	2021-01-26 00:00:00	2021-01-26 03:21:27	2021-01-26 03:22:04	2021-01-26 04:14:56	2021-01-26 04:38:39	21037	2.878600	2.61	NaN	NaN	NaN	1.0	auto	Reassignment Request from SE portal.	1.0	NaN	NaN

Last rows

	order_time	order_id	order_date	allot_time	accept_time	pickup_time	delivered_time	rider_id	first_mile_distance	last_mile_distance	alloted_orders	delivered_orders	undelivered_orders	lifetime_order_count	reassignment_method	reassignment_reason	reassigned_order	session_time	cancelled_time
449990	2021-02-06 10:03:00	130221	2021-02-06 00:00:00	2021-02-06 10:03:01	2021-02-06 10:04:03	2021-02-06 10:07:44	2021-02-06 10:15:03	3617	2.1965	1.24	22.0	22.0	0.0	34.0	NaN	NaN	NaN	376.416667	NaN
449991	2021-02-06 10:03:01	130222	2021-02-06 00:00:00	2021-02-06 10:04:30	2021-02-06 10:06:04	2021-02-06 10:26:23	2021-02-06 10:36:09	773	1.4707	1.12	147.0	146.0	1.0	773.0	NaN	NaN	NaN	268.166667	NaN
449992	2021-02-06 10:03:06	130223	2021-02-06 00:00:00	2021-02-06 10:03:47	2021-02-06 10:04:07	2021-02-06 10:15:01	2021-02-06 10:26:06	1407	0.3007	1.26	265.0	264.0	1.0	477.0	NaN	NaN	NaN	209.266667	NaN
449993	2021-02-06 10:03:11	130224	2021-02-06 00:00:00	2021-02-06 10:03:12	2021-02-06 10:03:35	2021-02-06 10:15:43	2021-02-06 10:25:14	745	2.7013	3.72	200.0	200.0	0.0	290.0	NaN	NaN	NaN	229.250000	NaN
449994	2021-02-06 10:03:14	130225	2021-02-06 00:00:00	2021-02-06 10:03:23	2021-02-06 10:03:43	2021-02-06 10:15:36	2021-02-06 10:34:10	7823	1.7916	2.60	202.0	201.0	1.0	1426.0	NaN	NaN	NaN	273.233333	NaN
449995	2021-02-06 10:03:16	130226	2021-02-06 00:00:00	2021-02-06 10:03:44	2021-02-06 10:04:14	2021-02-06 10:27:29	2021-02-06 10:44:08	1006	0.5789	0.19	4.0	4.0	0.0	127.0	NaN	NaN	NaN	369.516667	NaN
449996	2021-02-06 10:03:17	130227	2021-02-06 00:00:00	2021-02-06 10:03:18	2021-02-06 10:04:34	2021-02-06 10:22:17	2021-02-06 10:31:43	279	1.9863	1.19	81.0	81.0	0.0	105.0	NaN	NaN	NaN	239.133333	NaN
449997	2021-02-06 10:03:18	130228	2021-02-06 00:00:00	2021-02-06 10:04:06	2021-02-06 10:04:39	2021-02-06 10:19:06	2021-02-06 10:26:56	3161	1.5944	1.61	28.0	28.0	0.0	1488.0	NaN	NaN	NaN	204.150000	NaN
449998	2021-02-06 10:03:19	130229	2021-02-06 00:00:00	2021-02-06 10:03:19	2021-02-06 10:05:41	2021-02-06 10:20:39	2021-02-06 10:30:41	9396	2.8939	4.68	72.0	72.0	0.0	105.0	NaN	NaN	NaN	65.583333	NaN
449999	2021-02-06 10:03:24	130230	2021-02-06 00:00:00	2021-02-06 10:03:45	2021-02-06 10:05:14	2021-02-06 10:13:26	2021-02-06 10:19:41	2078	1.8925	0.09	30.0	30.0	0.0	108.0	NaN	NaN	NaN	212.000000	NaN

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters